﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ArticleDBConnection$" >
	<Sql>
		UPDATE eComProducts SET
			partId=@partId,
			supplierPartId=@supplierPartId,
			supplierId=supplierId,
			avgCostPrice=@avgCostPrice,
			listPrice=@listPrice,
			sellPrice=@sellPrice,
			sellPriceDescription=@sellPriceDescription,					 
			weight=@weight,
			weightUnit=@weightUnit,
			width=@width,
			widthUnit=@widthUnit,
			length=@length,
			lengthUnit=@lengthUnit,
			depth=@depth,
			depthUnit=@depthUnit,
			pricingId=@pricingId,
			shippingBoxOption=@shippingBoxOption,
			checkoutWizard=@checkoutWizard
		WHERE
			id=@id;			
	</Sql>

	<Param name="id" type="UniqueIdentifier"/>
	<Param name="companyId" type="UniqueIdentifier"/>
	<Param name="supplier.id" dbName="supplierId" type="UniqueIdentifier"/>
	<Param name="partId" type="UnicodeVarChar"/>
	<Param name="supplierPartId" type="UnicodeVarChar"/>
	<Param name="avgCostPrice" type="Money" />
	<Param name="listPrice" type="Money" />
	<Param name="sellPrice" type="Money" />
	<Param name="sellPriceDescription" type="UnicodeVarChar" />
	<Param name="weight.amount" dbName="weight"  type="Decimal" />
	<Param name="weight.unit" dbName="weightUnit"  type="UnicodeVarChar"/>
	<Param name="dimensions.width.amount" dbName="width" type="Decimal" />
	<Param name="dimensions.width.unit" dbName="widthUnit"  type="UnicodeVarChar"/>
	<Param name="dimensions.length.amount" dbName="length" type="Decimal" />
	<Param name="dimensions.length.unit" dbName="lengthUnit"  type="UnicodeVarChar"/>
	<Param name="dimensions.depth.amount" dbName="depth" type="Decimal" />
	<Param name="dimensions.depth.unit" dbName="depthUnit"  type="UnicodeVarChar"/>
	<Param name="pricingId" type="Char" />
	<Param name="shippingBoxOption" type="Integer" />
	<Param name="checkoutWizard" type="VarChar" />
</AdoNetDataAccess>